Working with Databases or Schemas

After you have created your connections, your databases/schemas appear in the navigation pane on the left. If the Show tables in connection tree option is checked at the Preferences, all database/schema objects are also displayed in the pane. To connect to a database/schema, simply double-click it in the pane. If connection succeeds, the database/schema node turns into or and expands showing the tree of its objects.

For Oracle server, when you create a user account, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) that the user creates. The schema name is the same as the user name, and can be used to unambiguously refer to objects owned by the user. Other user schemas are showed under Other Schemas.